if exists(select name from sysobjects where name = 'sp_UsersGetLogin')
	drop proc sp_UsersGetLogin
go
/*-- =============================================
	Created by: HP
	Created on: 2014-04-10 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_UsersGetLogin.sql
*/-- =============================================

CREATE PROCEDURE sp_UsersGetLogin
			
	@UserName varchar(32),
	@Pass varchar(64)
AS
BEGIN	
	SELECT
		a.[Id],
		a.[UserName],
		a.[Pass]
		
	FROM
		Users a
	WHERE
		   a.UserName=@UserName and a.pass=@Pass
END
GO
